The hidden benefits of SSMS

Comments 0

Share to social media

Every good DBA/developer writes their code with some comments/instructions at the top. Now in many cases this is important to have visible when running the code as it may give advice on the results or what certain column values will mean. Now you can split the code window, like you can in Excel but to my mind that just decreases the amount of information on the screen as you are dividing it into more parts.

My preference is to collapse the section of code by clicking the image_thumb_6.png at the top of the code section I want to execute and then highlight it with the mouse and run it, either with Ctrl + E or F5. This way we can read the comments about the script/results and see the results. Wonderful.

image_thumb_7.png

I hope this is of use to you, let me know your favourite SSMS tip or trick in the comments.

Load comments

About the author

Jonathan Allen

See Profile

Jonathan Allen has been a SQL Server DBA since 1999, most enjoying performance tuning and development but also working with SSIS, SSRS to provide suitable business solutions. He is SQLSouthWest PASS Chapter Leader, blogs for Simple Talk, is a forum moderator at ask.sqlservercentral.com and is on Twitter. If you would like to find your nearest user group or just want to say hello then he would love to get an email from you.

Jonathan Allen's contributions